Report

Dataset statistics

Number of variables	20
Number of observations	17784
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.7 MiB
Average record size in memory	160.0 B

Variable types

DateTime	3
Text	5
Categorical	7
Numeric	5

Alerts

`system` has constant value "http://snomed.info/sct"	Constant
`age_category` is highly overall correlated with `age_of_patient` and 1 other fields	High correlation
`age_of_patient` is highly overall correlated with `age_category` and 1 other fields	High correlation
`income` is highly overall correlated with `income_category`	High correlation
`income_category` is highly overall correlated with `income`	High correlation
`marital` is highly overall correlated with `age_category` and 1 other fields	High correlation
`length_of_procedure_in_hours` is highly skewed (γ1 = 50.36332377)	Skewed

Reproduction

Analysis started	2024-12-02 13:26:01.697171
Analysis finished	2024-12-02 13:26:12.407422
Duration	10.71 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

start_time
Date

Distinct	15176
Distinct (%)	85.3%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

Minimum	1962-09-02 13:37:48
Maximum	2024-11-04 08:21:17

Histogram with fixed size bins (bins=50)

stop_time
Date

Distinct	16254
Distinct (%)	91.4%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

Minimum	1962-09-02 13:52:48
Maximum	2024-11-04 08:40:55

Histogram with fixed size bins (bins=50)

patient_id
Text

Distinct	106
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	640224
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	30a6452c-4297-a1ac-977a-6a23237c7b46
2nd row	30a6452c-4297-a1ac-977a-6a23237c7b46
3rd row	30a6452c-4297-a1ac-977a-6a23237c7b46
4th row	30a6452c-4297-a1ac-977a-6a23237c7b46
5th row	30a6452c-4297-a1ac-977a-6a23237c7b46

Value	Count	Frequency (%)
d27273f0-f62d-7d7f-746d-4565f35cf176	1195	6.7%
d1622e8b-d26b-ec81-ffcb-ec4bf2af385b	1143	6.4%
bad5a231-3709-952a-cf44-f8d6a52cc214	1105	6.2%
4f159375-4ee4-36ab-b464-6d38f6ff2dae	946	5.3%
f3884e8a-8b36-1e93-66dd-e910dfab2ef5	871	4.9%
655baba7-47ed-22ac-2093-1196ebb44928	794	4.5%
cb1b46a1-9cb5-1187-ccc5-9fb7b98aa957	499	2.8%
14dc5e57-1b84-3305-c042-86c9fc7e4996	487	2.7%
6c602779-9775-f512-2724-fa4e0d0788f5	321	1.8%
bd2a8021-2868-6dd2-c17f-bfd7c36fe247	313	1.8%
Other values (96)	10110	56.8%

Most occurring characters

Value	Count	Frequency (%)
-	71136	11.1%
f	41315	6.5%
2	40559	6.3%
6	39774	6.2%
4	38074	5.9%
b	37100	5.8%
d	36525	5.7%
7	36162	5.6%
5	35681	5.6%
e	35624	5.6%
Other values (7)	228274	35.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	640224	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	71136	11.1%
f	41315	6.5%
2	40559	6.3%
6	39774	6.2%
4	38074	5.9%
b	37100	5.8%
d	36525	5.7%
7	36162	5.6%
5	35681	5.6%
e	35624	5.6%
Other values (7)	228274	35.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	640224	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	71136	11.1%
f	41315	6.5%
2	40559	6.3%
6	39774	6.2%
4	38074	5.9%
b	37100	5.8%
d	36525	5.7%
7	36162	5.6%
5	35681	5.6%
e	35624	5.6%
Other values (7)	228274	35.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	640224	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	71136	11.1%
f	41315	6.5%
2	40559	6.3%
6	39774	6.2%
4	38074	5.9%
b	37100	5.8%
d	36525	5.7%
7	36162	5.6%
5	35681	5.6%
e	35624	5.6%
Other values (7)	228274	35.7%

encounter_id
Text

Distinct	5269
Distinct (%)	29.6%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

Length

Max length	36
Median length	36
Mean length	36
Min length	36

Characters and Unicode

Total characters	640224
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2777 ?
Unique (%)	15.6%

Sample

1st row	953c5138-ce17-4084-3432-1ac23f184528
2nd row	953c5138-ce17-4084-3432-1ac23f184528
3rd row	0b03e41b-06a6-66fa-b972-acc5a83b134a
4th row	0b03e41b-06a6-66fa-b972-acc5a83b134a
5th row	0b03e41b-06a6-66fa-b972-acc5a83b134a

Value	Count	Frequency (%)
24fb9c92-a5ec-0f61-2daf-26506577c979	66	0.4%
9055f8ba-4010-33b5-b0b6-9503d9e2f43e	58	0.3%
d0a1f365-ea64-cd77-8658-d8ccc2a23c83	35	0.2%
d6a83835-7bbf-5aed-ceb1-1039fa5417e3	29	0.2%
b971075e-a389-6e13-e80e-d71b03b83ff9	26	0.1%
cf1dbb25-a1e9-b1b8-15c4-23433128fcac	26	0.1%
631bd5a6-5e05-7bd9-8dd7-d754c5606369	26	0.1%
40fb278c-4821-0c7b-08cc-9f79a2c4e0c4	26	0.1%
be80101e-9429-be41-eb41-255339860518	23	0.1%
569cfc5d-cfcd-80d8-8dea-ae1c476f4d64	22	0.1%
Other values (5259)	17447	98.1%

Most occurring characters

Value	Count	Frequency (%)
-	71136	11.1%
6	36088	5.6%
0	36085	5.6%
2	35852	5.6%
b	35841	5.6%
a	35773	5.6%
1	35699	5.6%
7	35658	5.6%
c	35647	5.6%
f	35592	5.6%
Other values (7)	246853	38.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	640224	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	71136	11.1%
6	36088	5.6%
0	36085	5.6%
2	35852	5.6%
b	35841	5.6%
a	35773	5.6%
1	35699	5.6%
7	35658	5.6%
c	35647	5.6%
f	35592	5.6%
Other values (7)	246853	38.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	640224	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	71136	11.1%
6	36088	5.6%
0	36085	5.6%
2	35852	5.6%
b	35841	5.6%
a	35773	5.6%
1	35699	5.6%
7	35658	5.6%
c	35647	5.6%
f	35592	5.6%
Other values (7)	246853	38.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	640224	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	71136	11.1%
6	36088	5.6%
0	36085	5.6%
2	35852	5.6%
b	35841	5.6%
a	35773	5.6%
1	35699	5.6%
7	35658	5.6%
c	35647	5.6%
f	35592	5.6%
Other values (7)	246853	38.6%

system
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

http://snomed.info/sct	17784

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	391248
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	http://snomed.info/sct
2nd row	http://snomed.info/sct
3rd row	http://snomed.info/sct
4th row	http://snomed.info/sct
5th row	http://snomed.info/sct

Common Values

Value	Count	Frequency (%)
http://snomed.info/sct	17784	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
http://snomed.info/sct	17784	100.0%

Most occurring characters

Value	Count	Frequency (%)
t	53352	13.6%
/	53352	13.6%
s	35568	9.1%
n	35568	9.1%
o	35568	9.1%
p	17784	4.5%
h	17784	4.5%
:	17784	4.5%
m	17784	4.5%
e	17784	4.5%
Other values (5)	88920	22.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	391248	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	53352	13.6%
/	53352	13.6%
s	35568	9.1%
n	35568	9.1%
o	35568	9.1%
p	17784	4.5%
h	17784	4.5%
:	17784	4.5%
m	17784	4.5%
e	17784	4.5%
Other values (5)	88920	22.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	391248	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	53352	13.6%
/	53352	13.6%
s	35568	9.1%
n	35568	9.1%
o	35568	9.1%
p	17784	4.5%
h	17784	4.5%
:	17784	4.5%
m	17784	4.5%
e	17784	4.5%
Other values (5)	88920	22.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	391248	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	53352	13.6%
/	53352	13.6%
s	35568	9.1%
n	35568	9.1%
o	35568	9.1%
p	17784	4.5%
h	17784	4.5%
:	17784	4.5%
m	17784	4.5%
e	17784	4.5%
Other values (5)	88920	22.7%

snomed_code
Real number (ℝ)

Distinct	225
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1105263 × 10¹³

Minimum	3802001
Maximum	4.56191 × 10¹⁴
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	139.1 KiB

Quantile statistics

Minimum	3802001
5-th percentile	34043003
Q1	1.7120701 × 10⁸
median	2.6576401 × 10⁸
Q3	7.10824 × 10⁸
95-th percentile	1.269321 × 10⁹
Maximum	4.56191 × 10¹⁴
Range	4.56191 × 10¹⁴
Interquartile range (IQR)	5.39617 × 10⁸

Descriptive statistics

Standard deviation	9.3196526 × 10¹³
Coefficient of variation (CV)	4.4157955
Kurtosis	15.591326
Mean	2.1105263 × 10¹³
Median Absolute Deviation (MAD)	1.62067 × 10⁸
Skewness	4.1924231
Sum	3.75336 × 10¹⁷
Variance	8.6855925 × 10²⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
171207006	1817	10.2%
265764009	1745	9.8%
710824005	1093	6.1%
430193006	788	4.4%
4.282110001 × 10¹⁴	738	4.1%
103697008	683	3.8%
34043003	678	3.8%
243085009	650	3.7%
1260009003	645	3.6%
1260010008	645	3.6%
Other values (215)	8302	46.7%

Value	Count	Frequency (%)
3802001	125	0.7%
5880005	84	0.5%
10383002	9	0.1%
11466000	6	< 0.1%
14736009	7	< 0.1%
14768001	12	0.1%
15081005	6	< 0.1%
18946005	8	< 0.1%
19589009	3	< 0.1%
22523008	1	< 0.1%

Value	Count	Frequency (%)
4.561910001 × 10¹⁴	130	0.7%
4.282110001 × 10¹⁴	738	4.1%
1.571000087 × 10¹²	3	< 0.1%
1290459008	6	< 0.1%
1290407002	3	< 0.1%
1269321004	26	0.1%
1263416007	8	< 0.1%
1260010008	645	3.6%
1260009003	645	3.6%
1259293006	55	0.3%

procedure_description
Text

Distinct	225
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

Length

Max length	163
Median length	93
Mean length	44.592949
Min length	10

Characters and Unicode

Total characters	793041
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	46 ?
Unique (%)	0.3%

Sample

1st row	Plain X-ray of pelvis (procedure)
2nd row	Admission to orthopedic department (procedure)
3rd row	Medication reconciliation (procedure)
4th row	Assessment of health and social care needs (procedure)
5th row	Assessment of anxiety (procedure)

Value	Count	Frequency (%)
procedure	16900	17.6%
of	5954	6.2%
dental	4496	4.7%
and	3337	3.5%
assessment	3183	3.3%
screening	2817	2.9%
care	2817	2.9%
using	2154	2.2%
depression	1941	2.0%
health	1883	2.0%
Other values (447)	50512	52.6%

Most occurring characters

Value	Count	Frequency (%)
e	98361	12.4%
	79474	10.0%
r	63091	8.0%
n	47675	6.0%
a	46942	5.9%
o	46924	5.9%
s	41822	5.3%
i	40953	5.2%
t	39463	5.0%
c	36733	4.6%
Other values (45)	251603	31.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	793041	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	98361	12.4%
	79474	10.0%
r	63091	8.0%
n	47675	6.0%
a	46942	5.9%
o	46924	5.9%
s	41822	5.3%
i	40953	5.2%
t	39463	5.0%
c	36733	4.6%
Other values (45)	251603	31.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	793041	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	98361	12.4%
	79474	10.0%
r	63091	8.0%
n	47675	6.0%
a	46942	5.9%
o	46924	5.9%
s	41822	5.3%
i	40953	5.2%
t	39463	5.0%
c	36733	4.6%
Other values (45)	251603	31.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	793041	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	98361	12.4%
	79474	10.0%
r	63091	8.0%
n	47675	6.0%
a	46942	5.9%
o	46924	5.9%
s	41822	5.3%
i	40953	5.2%
t	39463	5.0%
c	36733	4.6%
Other values (45)	251603	31.7%

base_cost
Real number (ℝ)

Distinct	2333
Distinct (%)	13.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	879.00884

Minimum	0.32
Maximum	32811.41
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	139.1 KiB

Quantile statistics

Minimum	0.32
5-th percentile	431.4
Q1	431.4
median	431.4
Q3	431.4
95-th percentile	3260.472
Maximum	32811.41
Range	32811.09
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1729.116
Coefficient of variation (CV)	1.9671202
Kurtosis	58.173311
Mean	879.00884
Median Absolute Deviation (MAD)	0
Skewness	6.57852
Sum	15632293
Variance	2989842.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
431.4	12848	72.2%
450.32	707	4.0%
862.8	397	2.2%
215.7	330	1.9%
2261.69	256	1.4%
1705.48	232	1.3%
3451.2	111	0.6%
9046.75	99	0.6%
1108.27	84	0.5%
25.88	70	0.4%
Other values (2323)	2650	14.9%

Value	Count	Frequency (%)
0.32	1	< 0.1%
0.44	1	< 0.1%
0.9	1	< 0.1%
0.92	1	< 0.1%
1.15	1	< 0.1%
2.09	1	< 0.1%
2.25	1	< 0.1%
2.39	1	< 0.1%
4.96	2	< 0.1%
25.88	70	0.4%

Value	Count	Frequency (%)
32811.41	1	< 0.1%
32592.18	1	< 0.1%
29161.5	1	< 0.1%
20647.87	2	< 0.1%
20484.38	7	< 0.1%
20211.6	4	< 0.1%
19825.4	1	< 0.1%
19154.79	1	< 0.1%
18823.5	1	< 0.1%
18802.78	1	< 0.1%

reason_code_for_procedure
Text

Distinct	60
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

Length

Max length	17
Median length	11
Mean length	8.7598403
Min length	7

Characters and Unicode

Total characters	155785
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	Unknown
2nd row	359817006.0
3rd row	Unknown
4th row	Unknown
5th row	Unknown

Value	Count	Frequency (%)
unknown	8645	48.6%
66383009.0	2384	13.4%
103697008.0	2093	11.8%
72892002.0	1696	9.5%
431857002.0	1032	5.8%
46177005.0	578	3.3%
18718003.0	279	1.6%
254837009.0	169	1.0%
39898005.0	97	0.5%
427898007.0	84	0.5%
Other values (50)	727	4.1%

Most occurring characters

Value	Count	Frequency (%)
0	30030	19.3%
n	25935	16.6%
.	9139	5.9%
3	8872	5.7%
8	8714	5.6%
k	8645	5.5%
o	8645	5.5%
U	8645	5.5%
w	8645	5.5%
6	8007	5.1%
Other values (6)	30508	19.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	155785	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	30030	19.3%
n	25935	16.6%
.	9139	5.9%
3	8872	5.7%
8	8714	5.6%
k	8645	5.5%
o	8645	5.5%
U	8645	5.5%
w	8645	5.5%
6	8007	5.1%
Other values (6)	30508	19.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	155785	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	30030	19.3%
n	25935	16.6%
.	9139	5.9%
3	8872	5.7%
8	8714	5.6%
k	8645	5.5%
o	8645	5.5%
U	8645	5.5%
w	8645	5.5%
6	8007	5.1%
Other values (6)	30508	19.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	155785	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	30030	19.3%
n	25935	16.6%
.	9139	5.9%
3	8872	5.7%
8	8714	5.6%
k	8645	5.5%
o	8645	5.5%
U	8645	5.5%
w	8645	5.5%
6	8007	5.1%
Other values (6)	30508	19.6%

reason_description_for_procedure
Text

Distinct	60
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

Length

Max length	78
Median length	70
Mean length	19.861673
Min length	7

Characters and Unicode

Total characters	353220
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	Unknown
2nd row	Closed fracture of hip (disorder)
3rd row	Unknown
4th row	Unknown
5th row	Unknown

Value	Count	Frequency (%)
unknown	8645	19.2%
disorder	5262	11.7%
gingivitis	2384	5.3%
dental	2220	4.9%
procedure	2093	4.6%
for	2093	4.6%
referral	2093	4.6%
patient	2093	4.6%
care	2093	4.6%
disease	1912	4.2%
Other values (121)	14150	31.4%

Most occurring characters

Value	Count	Frequency (%)
n	44968	12.7%
r	31467	8.9%
e	30660	8.7%
	27254	7.7%
i	26810	7.6%
o	22711	6.4%
d	20506	5.8%
a	18281	5.2%
s	14362	4.1%
t	12608	3.6%
Other values (41)	103593	29.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	353220	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	44968	12.7%
r	31467	8.9%
e	30660	8.7%
	27254	7.7%
i	26810	7.6%
o	22711	6.4%
d	20506	5.8%
a	18281	5.2%
s	14362	4.1%
t	12608	3.6%
Other values (41)	103593	29.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	353220	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	44968	12.7%
r	31467	8.9%
e	30660	8.7%
	27254	7.7%
i	26810	7.6%
o	22711	6.4%
d	20506	5.8%
a	18281	5.2%
s	14362	4.1%
t	12608	3.6%
Other values (41)	103593	29.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	353220	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	44968	12.7%
r	31467	8.9%
e	30660	8.7%
	27254	7.7%
i	26810	7.6%
o	22711	6.4%
d	20506	5.8%
a	18281	5.2%
s	14362	4.1%
t	12608	3.6%
Other values (41)	103593	29.3%

length_of_procedure_in_hours
Real number (ℝ)

Skewed

Distinct	3334
Distinct (%)	18.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.69234491

Minimum	0.036111111
Maximum	134
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	139.1 KiB

Quantile statistics

Minimum	0.036111111
5-th percentile	0.17111111
Q1	0.25
median	0.39833333
Q3	0.63055556
95-th percentile	3
Maximum	134
Range	133.96389
Interquartile range (IQR)	0.38055556

Descriptive statistics

Standard deviation	1.5688371
Coefficient of variation (CV)	2.2659762
Kurtosis	3805.1
Mean	0.69234491
Median Absolute Deviation (MAD)	0.14833333
Skewness	50.363324
Sum	12312.662
Variance	2.4612497
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.25	3203	18.0%
0.5	408	2.3%
0.08333333333	153	0.9%
0.1666666667	95	0.5%
1	41	0.2%
3.05	25	0.1%
2.433333333	24	0.1%
3.266666667	22	0.1%
3.233333333	22	0.1%
2.733333333	21	0.1%
Other values (3324)	13770	77.4%

Value	Count	Frequency (%)
0.03611111111	1	< 0.1%
0.05055555556	1	< 0.1%
0.07166666667	1	< 0.1%
0.08333333333	153	0.9%
0.08361111111	3	< 0.1%
0.08388888889	1	< 0.1%
0.08416666667	3	< 0.1%
0.08444444444	1	< 0.1%
0.085	3	< 0.1%
0.08527777778	3	< 0.1%

Value	Count	Frequency (%)
134	1	< 0.1%
98	1	< 0.1%
37	1	< 0.1%
34	1	< 0.1%
30	1	< 0.1%
28	1	< 0.1%
24	1	< 0.1%
5.916666667	1	< 0.1%
4.35	1	< 0.1%
3.983333333	11	0.1%

birthdate
Date

Distinct	100
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

Minimum	1914-03-03 00:00:00
Maximum	2023-03-01 00:00:00

Histogram with fixed size bins (bins=50)

marital
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

M	9369
Unknown	3502
D	2670
S	1720
W	523

Length

Max length	7
Median length	1
Mean length	2.1815115
Min length	1

Characters and Unicode

Total characters	38796
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
M	9369	52.7%
Unknown	3502	19.7%
D	2670	15.0%
S	1720	9.7%
W	523	2.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	9369	52.7%
unknown	3502	19.7%
d	2670	15.0%
s	1720	9.7%
w	523	2.9%

Most occurring characters

Value	Count	Frequency (%)
n	10506	27.1%
M	9369	24.1%
U	3502	9.0%
k	3502	9.0%
o	3502	9.0%
w	3502	9.0%
D	2670	6.9%
S	1720	4.4%
W	523	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	38796	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	10506	27.1%
M	9369	24.1%
U	3502	9.0%
k	3502	9.0%
o	3502	9.0%
w	3502	9.0%
D	2670	6.9%
S	1720	4.4%
W	523	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	38796	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	10506	27.1%
M	9369	24.1%
U	3502	9.0%
k	3502	9.0%
o	3502	9.0%
w	3502	9.0%
D	2670	6.9%
S	1720	4.4%
W	523	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	38796	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	10506	27.1%
M	9369	24.1%
U	3502	9.0%
k	3502	9.0%
o	3502	9.0%
w	3502	9.0%
D	2670	6.9%
S	1720	4.4%
W	523	1.3%

race
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

white	13551
asian	2195
other	1169
black	791
native	78

Length

Max length	6
Median length	5
Mean length	5.004386
Min length	5

Characters and Unicode

Total characters	88998
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	white
2nd row	white
3rd row	white
4th row	white
5th row	white

Common Values

Value	Count	Frequency (%)
white	13551	76.2%
asian	2195	12.3%
other	1169	6.6%
black	791	4.4%
native	78	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
white	13551	76.2%
asian	2195	12.3%
other	1169	6.6%
black	791	4.4%
native	78	0.4%

Most occurring characters

Value	Count	Frequency (%)
i	15824	17.8%
e	14798	16.6%
t	14798	16.6%
h	14720	16.5%
w	13551	15.2%
a	5259	5.9%
n	2273	2.6%
s	2195	2.5%
o	1169	1.3%
r	1169	1.3%
Other values (5)	3242	3.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	88998	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	15824	17.8%
e	14798	16.6%
t	14798	16.6%
h	14720	16.5%
w	13551	15.2%
a	5259	5.9%
n	2273	2.6%
s	2195	2.5%
o	1169	1.3%
r	1169	1.3%
Other values (5)	3242	3.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	88998	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	15824	17.8%
e	14798	16.6%
t	14798	16.6%
h	14720	16.5%
w	13551	15.2%
a	5259	5.9%
n	2273	2.6%
s	2195	2.5%
o	1169	1.3%
r	1169	1.3%
Other values (5)	3242	3.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	88998	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	15824	17.8%
e	14798	16.6%
t	14798	16.6%
h	14720	16.5%
w	13551	15.2%
a	5259	5.9%
n	2273	2.6%
s	2195	2.5%
o	1169	1.3%
r	1169	1.3%
Other values (5)	3242	3.6%

ethnicity
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

nonhispanic	15821
hispanic	1963

Length

Max length	11
Median length	11
Mean length	10.66886
Min length	8

Characters and Unicode

Total characters	189735
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	nonhispanic
2nd row	nonhispanic
3rd row	nonhispanic
4th row	nonhispanic
5th row	nonhispanic

Common Values

Value	Count	Frequency (%)
nonhispanic	15821	89.0%
hispanic	1963	11.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
nonhispanic	15821	89.0%
hispanic	1963	11.0%

Most occurring characters

Value	Count	Frequency (%)
n	49426	26.1%
i	35568	18.7%
h	17784	9.4%
s	17784	9.4%
a	17784	9.4%
p	17784	9.4%
c	17784	9.4%
o	15821	8.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	189735	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	49426	26.1%
i	35568	18.7%
h	17784	9.4%
s	17784	9.4%
a	17784	9.4%
p	17784	9.4%
c	17784	9.4%
o	15821	8.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	189735	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	49426	26.1%
i	35568	18.7%
h	17784	9.4%
s	17784	9.4%
a	17784	9.4%
p	17784	9.4%
c	17784	9.4%
o	15821	8.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	189735	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	49426	26.1%
i	35568	18.7%
h	17784	9.4%
s	17784	9.4%
a	17784	9.4%
p	17784	9.4%
c	17784	9.4%
o	15821	8.3%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

F	9437
M	8347

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	17784
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	M
5th row	M

Common Values

Value	Count	Frequency (%)
F	9437	53.1%
M	8347	46.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	9437	53.1%
m	8347	46.9%

Most occurring characters

Value	Count	Frequency (%)
F	9437	53.1%
M	8347	46.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17784	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
F	9437	53.1%
M	8347	46.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17784	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
F	9437	53.1%
M	8347	46.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17784	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
F	9437	53.1%
M	8347	46.9%

income
Real number (ℝ)

High correlation

Distinct	100
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	104532.45

Minimum	7361
Maximum	816851
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	139.1 KiB

Quantile statistics

Minimum	7361
5-th percentile	16969
Q1	49737
median	86384
Q3	118047
95-th percentile	189277
Maximum	816851
Range	809490
Interquartile range (IQR)	68310

Descriptive statistics

Standard deviation	116932.58
Coefficient of variation (CV)	1.1186247
Kurtosis	22.04659
Mean	104532.45
Median Absolute Deviation (MAD)	31663
Skewness	4.4189992
Sum	1.8590051 × 10⁹
Variance	1.3673228 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
92537	1323	7.4%
82922	1195	6.7%
90297	1107	6.2%
118047	1105	6.2%
189277	946	5.3%
35860	871	4.9%
63727	499	2.8%
72413	487	2.7%
95344	396	2.2%
179090	321	1.8%
Other values (90)	9534	53.6%

Value	Count	Frequency (%)
7361	237	1.3%
7873	70	0.4%
8615	95	0.5%
8752	162	0.9%
10135	6	< 0.1%
10682	89	0.5%
12128	131	0.7%
16969	183	1.0%
17382	105	0.6%
18258	119	0.7%

Value	Count	Frequency (%)
816851	126	0.7%
762068	67	0.4%
742063	206	1.2%
550030	99	0.6%
545255	2	< 0.1%
198522	106	0.6%
198442	150	0.8%
189277	946	5.3%
188023	122	0.7%
179090	321	1.8%

income_category
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

high-income	8805
medium-income	4623
low-income	4356

Length

Max length	13
Median length	11
Mean length	11.274966
Min length	10

Characters and Unicode

Total characters	200514
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	high-income
2nd row	high-income
3rd row	high-income
4th row	high-income
5th row	high-income

Common Values

Value	Count	Frequency (%)
high-income	8805	49.5%
medium-income	4623	26.0%
low-income	4356	24.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
high-income	8805	49.5%
medium-income	4623	26.0%
low-income	4356	24.5%

Most occurring characters

Value	Count	Frequency (%)
i	31212	15.6%
m	27030	13.5%
e	22407	11.2%
o	22140	11.0%
n	17784	8.9%
-	17784	8.9%
c	17784	8.9%
h	17610	8.8%
g	8805	4.4%
d	4623	2.3%
Other values (3)	13335	6.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	200514	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	31212	15.6%
m	27030	13.5%
e	22407	11.2%
o	22140	11.0%
n	17784	8.9%
-	17784	8.9%
c	17784	8.9%
h	17610	8.8%
g	8805	4.4%
d	4623	2.3%
Other values (3)	13335	6.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	200514	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	31212	15.6%
m	27030	13.5%
e	22407	11.2%
o	22140	11.0%
n	17784	8.9%
-	17784	8.9%
c	17784	8.9%
h	17610	8.8%
g	8805	4.4%
d	4623	2.3%
Other values (3)	13335	6.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	200514	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	31212	15.6%
m	27030	13.5%
e	22407	11.2%
o	22140	11.0%
n	17784	8.9%
-	17784	8.9%
c	17784	8.9%
h	17610	8.8%
g	8805	4.4%
d	4623	2.3%
Other values (3)	13335	6.7%

age_of_patient
Real number (ℝ)

High correlation

Distinct	4243
Distinct (%)	23.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.380178

Minimum	0
Maximum	110.04384
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	139.1 KiB

Quantile statistics

Minimum	0
5-th percentile	10.049315
Q1	30.876712
median	51.090411
Q3	65.569863
95-th percentile	80.161096
Maximum	110.04384
Range	110.04384
Interquartile range (IQR)	34.693151

Descriptive statistics

Standard deviation	22.903156
Coefficient of variation (CV)	0.47339958
Kurtosis	-0.78133396
Mean	48.380178
Median Absolute Deviation (MAD)	16.991781
Skewness	-0.1300737
Sum	860393.08
Variance	524.55455
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11.06575342	109	0.6%
10.04931507	100	0.6%
12.0630137	100	0.6%
14.09589041	90	0.5%
15.11232877	88	0.5%
13.07945205	88	0.5%
8.016438356	79	0.4%
16.12876712	73	0.4%
19.17808219	71	0.4%
59.18356164	69	0.4%
Other values (4233)	16917	95.1%

Value	Count	Frequency (%)
0	5	< 0.1%
0.09589041096	6	< 0.1%
0.2684931507	5	< 0.1%
0.4410958904	3	< 0.1%
0.6904109589	8	< 0.1%
0.8849315068	2	< 0.1%
0.898630137	2	< 0.1%
0.9095890411	1	< 0.1%
0.9397260274	8	< 0.1%
0.9589041096	1	< 0.1%

Value	Count	Frequency (%)
110.0438356	13	0.1%
110.0054795	8	< 0.1%
108.9890411	4	< 0.1%
108.0109589	8	< 0.1%
107.9726027	3	< 0.1%
107.709589	2	< 0.1%
107.7068493	2	< 0.1%
107.7041096	1	< 0.1%
107.7013699	1	< 0.1%
107.6986301	2	< 0.1%

age_category
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	139.1 KiB

adult	10821
senior	4797
children	2166

Length

Max length	8
Median length	5
Mean length	5.6351215
Min length	5

Characters and Unicode

Total characters	100215
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	adult
2nd row	adult
3rd row	adult
4th row	adult
5th row	adult

Common Values

Value	Count	Frequency (%)
adult	10821	60.8%
senior	4797	27.0%
children	2166	12.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
adult	10821	60.8%
senior	4797	27.0%
children	2166	12.2%

Most occurring characters

Value	Count	Frequency (%)
d	12987	13.0%
l	12987	13.0%
a	10821	10.8%
u	10821	10.8%
t	10821	10.8%
e	6963	6.9%
n	6963	6.9%
i	6963	6.9%
r	6963	6.9%
s	4797	4.8%
Other values (3)	9129	9.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100215	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
d	12987	13.0%
l	12987	13.0%
a	10821	10.8%
u	10821	10.8%
t	10821	10.8%
e	6963	6.9%
n	6963	6.9%
i	6963	6.9%
r	6963	6.9%
s	4797	4.8%
Other values (3)	9129	9.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100215	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
d	12987	13.0%
l	12987	13.0%
a	10821	10.8%
u	10821	10.8%
t	10821	10.8%
e	6963	6.9%
n	6963	6.9%
i	6963	6.9%
r	6963	6.9%
s	4797	4.8%
Other values (3)	9129	9.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100215	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
d	12987	13.0%
l	12987	13.0%
a	10821	10.8%
u	10821	10.8%
t	10821	10.8%
e	6963	6.9%
n	6963	6.9%
i	6963	6.9%
r	6963	6.9%
s	4797	4.8%
Other values (3)	9129	9.1%

	age_category	age_of_patient	base_cost	ethnicity	gender	income	income_category	length_of_procedure_in_hours	marital	race	snomed_code
age_category	1.000	0.886	0.095	0.202	0.165	0.266	0.177	0.000	0.568	0.310	0.442
age_of_patient	0.886	1.000	-0.019	0.314	0.400	0.177	0.335	0.212	0.528	0.441	0.096
base_cost	0.095	-0.019	1.000	0.075	0.143	0.089	0.031	0.150	0.054	0.032	-0.195
ethnicity	0.202	0.314	0.075	1.000	0.163	0.245	0.037	0.017	0.158	0.174	0.255
gender	0.165	0.400	0.143	0.163	1.000	0.363	0.181	0.000	0.258	0.409	0.353
income	0.266	0.177	0.089	0.245	0.363	1.000	0.707	0.075	0.172	0.239	-0.000
income_category	0.177	0.335	0.031	0.037	0.181	0.707	1.000	0.000	0.225	0.244	0.206
length_of_procedure_in_hours	0.000	0.212	0.150	0.017	0.000	0.075	0.000	1.000	0.005	0.000	0.122
marital	0.568	0.528	0.054	0.158	0.258	0.172	0.225	0.005	1.000	0.260	0.251
race	0.310	0.441	0.032	0.174	0.409	0.239	0.244	0.000	0.260	1.000	0.190
snomed_code	0.442	0.096	-0.195	0.255	0.353	-0.000	0.206	0.122	0.251	0.190	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	start_time	stop_time	patient_id	encounter_id	system	snomed_code	procedure_description	base_cost	reason_code_for_procedure	reason_description_for_procedure	length_of_procedure_in_hours	birthdate	marital	race	ethnicity	gender	income	income_category	age_of_patient	age_category
0	2015-09-28 09:04:48	2015-09-28 09:34:48	30a6452c-4297-a1ac-977a-6a23237c7b46	953c5138-ce17-4084-3432-1ac23f184528	http://snomed.info/sct	713021002	Plain X-ray of pelvis (procedure)	431.4	Unknown	Unknown	0.500000	1994-02-06	M	white	nonhispanic	M	100511	high-income	21.654795	adult
1	2015-09-28 09:04:48	2015-09-28 11:02:48	30a6452c-4297-a1ac-977a-6a23237c7b46	953c5138-ce17-4084-3432-1ac23f184528	http://snomed.info/sct	305428000	Admission to orthopedic department (procedure)	431.4	359817006.0	Closed fracture of hip (disorder)	1.966667	1994-02-06	M	white	nonhispanic	M	100511	high-income	21.654795	adult
2	2016-04-10 09:04:48	2016-04-10 09:19:48	30a6452c-4297-a1ac-977a-6a23237c7b46	0b03e41b-06a6-66fa-b972-acc5a83b134a	http://snomed.info/sct	430193006	Medication reconciliation (procedure)	852.4	Unknown	Unknown	0.250000	1994-02-06	M	white	nonhispanic	M	100511	high-income	22.189041	adult
3	2016-04-10 09:04:48	2016-04-10 10:00:45	30a6452c-4297-a1ac-977a-6a23237c7b46	0b03e41b-06a6-66fa-b972-acc5a83b134a	http://snomed.info/sct	710824005	Assessment of health and social care needs (procedure)	431.4	Unknown	Unknown	0.932500	1994-02-06	M	white	nonhispanic	M	100511	high-income	22.189041	adult
4	2016-04-10 10:00:45	2016-04-10 10:22:03	30a6452c-4297-a1ac-977a-6a23237c7b46	0b03e41b-06a6-66fa-b972-acc5a83b134a	http://snomed.info/sct	710841007	Assessment of anxiety (procedure)	431.4	Unknown	Unknown	0.355000	1994-02-06	M	white	nonhispanic	M	100511	high-income	22.189041	adult
5	2016-04-10 10:22:03	2016-04-10 10:57:35	30a6452c-4297-a1ac-977a-6a23237c7b46	0b03e41b-06a6-66fa-b972-acc5a83b134a	http://snomed.info/sct	866148006	Screening for domestic abuse (procedure)	431.4	Unknown	Unknown	0.592222	1994-02-06	M	white	nonhispanic	M	100511	high-income	22.189041	adult
6	2016-04-10 10:57:35	2016-04-10 11:12:09	30a6452c-4297-a1ac-977a-6a23237c7b46	0b03e41b-06a6-66fa-b972-acc5a83b134a	http://snomed.info/sct	171207006	Depression screening (procedure)	431.4	Unknown	Unknown	0.242778	1994-02-06	M	white	nonhispanic	M	100511	high-income	22.189041	adult
7	2016-04-10 11:12:09	2016-04-10 11:33:02	30a6452c-4297-a1ac-977a-6a23237c7b46	0b03e41b-06a6-66fa-b972-acc5a83b134a	http://snomed.info/sct	171207006	Depression screening (procedure)	431.4	Unknown	Unknown	0.348056	1994-02-06	M	white	nonhispanic	M	100511	high-income	22.189041	adult
8	2016-04-10 11:33:02	2016-04-10 11:46:15	30a6452c-4297-a1ac-977a-6a23237c7b46	0b03e41b-06a6-66fa-b972-acc5a83b134a	http://snomed.info/sct	428211000124100	Assessment of substance use (procedure)	431.4	Unknown	Unknown	0.220278	1994-02-06	M	white	nonhispanic	M	100511	high-income	22.189041	adult
9	2016-04-10 11:46:15	2016-04-10 12:07:28	30a6452c-4297-a1ac-977a-6a23237c7b46	0b03e41b-06a6-66fa-b972-acc5a83b134a	http://snomed.info/sct	713106006	Screening for drug abuse (procedure)	431.4	Unknown	Unknown	0.353611	1994-02-06	M	white	nonhispanic	M	100511	high-income	22.189041	adult

	start_time	stop_time	patient_id	encounter_id	system	snomed_code	procedure_description	base_cost	reason_code_for_procedure	reason_description_for_procedure	length_of_procedure_in_hours	birthdate	marital	race	ethnicity	gender	income	income_category	age_of_patient	age_category
17774	2024-09-26 09:58:21	2024-09-26 10:38:50	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	225362009	Dental care (regime/therapy)	431.4	66383009.0	Gingivitis (disorder)	0.674722	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17775	2024-09-26 10:38:50	2024-09-26 11:25:53	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	1260009003	Removal of supragingival plaque and calculus from all teeth using dental instrument (procedure)	431.4	66383009.0	Gingivitis (disorder)	0.784167	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17776	2024-09-26 11:25:53	2024-09-26 12:16:45	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	1260010008	Removal of subgingival plaque and calculus from all teeth using dental instrument (procedure)	431.4	66383009.0	Gingivitis (disorder)	0.847778	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17777	2024-09-26 12:16:45	2024-09-26 12:46:45	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	241046008	Dental plain X-ray bitewing (procedure)	431.4	Unknown	Unknown	0.500000	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17778	2024-09-26 12:16:45	2024-09-26 12:25:12	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	81733005	Dental surgical procedure (procedure)	431.4	427898007.0	Infection of tooth (disorder)	0.140833	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17779	2024-09-26 12:25:12	2024-09-26 13:45:10	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	3802001	Dental application of desensitizing medicament (procedure)	431.4	427898007.0	Infection of tooth (disorder)	1.332778	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17780	2024-09-26 13:45:10	2024-09-26 14:25:44	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	173291009	Simple extraction of tooth (procedure)	431.4	427898007.0	Infection of tooth (disorder)	0.676111	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17781	2024-09-26 14:25:44	2024-09-26 15:34:23	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	456191000124101	Postoperative care for dental procedure (regime/therapy)	431.4	Unknown	Unknown	1.144167	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17782	2024-09-26 15:34:23	2024-09-26 16:19:44	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	274788003	Examination of gingivae (procedure)	431.4	66383009.0	Gingivitis (disorder)	0.755833	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior
17783	2024-09-26 16:19:44	2024-09-26 16:31:42	f339a5f7-0b09-3072-2b01-7c8e8ca2c1fc	8fb043ba-08be-2a3a-1011-c3019f2b7d07	http://snomed.info/sct	243085009	Oral health education (procedure)	431.4	66383009.0	Gingivitis (disorder)	0.199444	1951-11-22	S	asian	nonhispanic	F	92537	high-income	72.89589	senior

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length